﻿CREATE TABLE [dbo].[Mandant]
(
	[ID]        UNIQUEIDENTIFIER NOT NULL primary key,
    [Firma]  NVARCHAR (500)   NULL,
	[Straße]  NVARCHAR (500)   NULL,
	[HSNR]  NVARCHAR (500)   NULL,
	[PLZ] INT NOT NULL default(0),
	[Ort]  NVARCHAR (500)   NULL,
	[Mandant_Nr] INT NOT NULL default(0),
	[Master_PW]  NVARCHAR (500)   NULL,
	[User] INT NOT NULL default(0),
	[Date]  DATETIME  NULL
)
